High Impact Data Visualization in Excel with Power View, 3D Maps, Get & Transform and Power BI by Adam Aspin

Author:Adam Aspin
Language: eng
Format: epub
Publisher: Apress, Berkeley, CA

Note

To unpin a data source from the Recent Sources menu and the Recent Sources dialog, all you have to do is click the pin icon for a pinned data source. This unpins it, and it reappears in the list of recently used data sources.

Old Data

When you open a Excel 2016 file that you have not used in some time, you could well see a message above the data pane indicating that the data ingested using Get & Transform is old and potentially out of date.

Simply click the Refresh button (if that is what you want to do). The preview data is refreshed, and the latest data is loaded.

Tip

You do not have to exit the Get & Transform Query Editor to create a new query. All you have to do is to switch to the Home ribbon and click the New Source button (or even the Recent Sources button) to add a new query.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.